<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1" import="java.sql.*,java.io.*,javax.servlet.*,javax.servlet.http.*,java.sql.Connection,java.sql.DriverManager,java.util.*"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<%
try{
Connection con =org.tmad.ocms.dao.ConnectionManager.getDbConnection();
Statement stmt =con.createStatement();
String email = request.getParameter("email");
ResultSet rs =stmt.executeQuery("select * from casereg ");
while(rs.next()){
	casetype=rs.getString(9);
	helpcategory=rs.getString(8);
	summaryofthecase=rs.getString(6);	
	description=rs.getString(7);
	needyname=rs.getString(2);
	adress=rs.getString(3);
	city=rs.getString(4);
	state=rs.getString(16);
	postalcode=rs.getString(5);
	mobile=rs.getString(14);
	contactphone=rs.getString(13);
	contactmail=rs.getString(15);
%>
<h3>CaseType:<%=casetype%></h3>	
 <h3>HelpCategory:<%=helpcategory%></h3>	
  <h3>SummaryofTheCase:<%=summaryofthecase%></h3>	
  <h3>Description:<%=description%></h3>	
  <h3>NeedyName:<%=needyname%></h3>	
  <h3>Address:<%=address%></h3>	
  <h3>City:<%=city%></h3>	
  <h3>state:<%=state%></h3>
  <h3>PostalCode:<%=postalcode%></h3>	
  <h3>mobile:<%=mobile%></h3>	
  <h3>ContactPhone:<%=contactphone%></h3>
  <h3>ContactMail:<%=contactmail%></h3>	
  <%
}
  %>
  <%
  catch(Exception e){
	e.printStackTrace();  
  } %>

</body>
</html>